How to: Modify a query in Datasheet view.
Solution:
Select the query to modify from the list in the Database window, click 'Open' and modify the query.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the query to modify from the list.
4) Click 'Open'. (The query opens in Datasheet view.)
5) Modify the query with any edits or changes.
6) Select the 'File' menu and select 'Save'.